QCC Data Warehouse

What’s the value add of the data warehouse?

• Effective dating

• Snapshots

• Automation

• User friendly interface

Effective Dating

• But CUNY First has effective dates?

Effective Dating

• Many cunyfirst tables don’t have effective dates

• Almost no tables in CUNY first have end dates

Effective Dating

• Many cunyfirst tables don’t have effective dates

• Almost no tables in CUNY first have end dates

• The data warehouse daily scans our CUNY First data, finds changes in records, and creates effective dates/end dates

Snapshots

• Historical static views of CUNY First at specified points in history

• Census dates, first day of term, current offset

Snapshots

Automation

Automation

• IT has this all set up automatically

• The reporting instance query

• Extraction from tumbleweed

• The effective dating

• The snapshots

User Interface

• OBIEE web app interface

• Abstracts away leftover complexity of datawarehouse

• No SQL required

• Drag and drop gui